SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vweFunciones
AS
SELECT     idFuncion AS ID, Descripcion, Mnemo, Horas, Puntos, Sistema, RegimenLaboral, Financiamiento, Finalidad, TipoDeFuncion, Presupuesto, RegimenSalarial, 
                      RegimenSuplencias, RegimenDesigna, Temporalidad
FROM         dbo.tb_Funciones



GO
GRANT SELECT ON  [dbo].[vweFunciones] TO [CentroDeDesignaciones]
GRANT SELECT ON  [dbo].[vweFunciones] TO [Direcciones De Nivel]
GRANT INSERT ON  [dbo].[vweFunciones] TO [Direcciones De Nivel]
GRANT DELETE ON  [dbo].[vweFunciones] TO [Direcciones De Nivel]
GRANT UPDATE ON  [dbo].[vweFunciones] TO [Direcciones De Nivel]
GRANT SELECT ON  [dbo].[vweFunciones] TO [PersonalDocente]
GRANT INSERT ON  [dbo].[vweFunciones] TO [PersonalDocente]
GRANT DELETE ON  [dbo].[vweFunciones] TO [PersonalDocente]
GRANT UPDATE ON  [dbo].[vweFunciones] TO [PersonalDocente]
GRANT REFERENCES ON  [dbo].[vweFunciones] TO [Reestructura]
GRANT SELECT ON  [dbo].[vweFunciones] TO [Reestructura]
GRANT INSERT ON  [dbo].[vweFunciones] TO [Reestructura]
GRANT DELETE ON  [dbo].[vweFunciones] TO [Reestructura]
GRANT UPDATE ON  [dbo].[vweFunciones] TO [Reestructura]
GRANT SELECT ON  [dbo].[vweFunciones] TO [SoloVer]
GO
